Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 341706 |
| Missing cells | 180740 |
| Missing cells (%) | 1.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 444.1 MiB |
| Average record size in memory | 1.3 KiB |
Variable types
| Text | 2 |
|---|---|
| Categorical | 10 |
| Numeric | 12 |
| DateTime | 2 |
| Unsupported | 4 |
BANCOS_CREDITOS_ACTIVOS is highly overall correlated with BANCOS_CREDITOS_ACTIVOS_1 | High correlation |
BANCOS_CREDITOS_ACTIVOS_1 is highly overall correlated with BANCOS_CREDITOS_ACTIVOS | High correlation |
Base is highly overall correlated with Motivo_Renuencia_Cliente and 4 other fields | High correlation |
CUOTAS_MERCADO_1 is highly overall correlated with SALDO_CASTIGO_DATACREDITO and 5 other fields | High correlation |
Edad__c is highly overall correlated with RANGO_EDAD and 1 other fields | High correlation |
Motivo_Renuencia_Cliente is highly overall correlated with Base and 4 other fields | High correlation |
Operado_Por__c is highly overall correlated with Base and 3 other fields | High correlation |
RANGO_EDAD is highly overall correlated with Edad__c and 1 other fields | High correlation |
RANGO_EDAD_1 is highly overall correlated with Edad__c and 1 other fields | High correlation |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO is highly overall correlated with RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 | High correlation |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 is highly overall correlated with RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO | High correlation |
SALDO_CASTIGO_DATACREDITO is highly overall correlated with CUOTAS_MERCADO_1 and 5 other fields | High correlation |
SALDO_CASTIGO_DATACREDITO_1 is highly overall correlated with CUOTAS_MERCADO_1 and 5 other fields | High correlation |
SALDO_TOTAL_DATACREDITO is highly overall correlated with CUOTAS_MERCADO_1 and 5 other fields | High correlation |
SALDO_TOTAL_DATACREDITO_1 is highly overall correlated with CUOTAS_MERCADO_1 and 5 other fields | High correlation |
Saldo_Capital_cliente is highly overall correlated with CUOTAS_MERCADO_1 and 5 other fields | High correlation |
Saldo_Total_cliente is highly overall correlated with CUOTAS_MERCADO_1 and 5 other fields | High correlation |
Tipo_Cliente is highly overall correlated with Base and 4 other fields | High correlation |
estado is highly overall correlated with Base and 3 other fields | High correlation |
localizado_historico is highly overall correlated with Base and 2 other fields | High correlation |
RANGO_EDAD has 9533 (2.8%) missing values | Missing |
SALDO_TOTAL_DATACREDITO has 8327 (2.4%) missing values | Missing |
SALDO_CASTIGO_DATACREDITO has 8747 (2.6%) missing values | Missing |
BANCOS_CREDITOS_ACTIVOS has 13793 (4.0%) missing values | Missing |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO has 8489 (2.5%) missing values | Missing |
RANGO_EDAD_1 has 3722 (1.1%) missing values | Missing |
CUOTAS_MERCADO_1 has 3538 (1.0%) missing values | Missing |
SALDO_TOTAL_DATACREDITO_1 has 15231 (4.5%) missing values | Missing |
SALDO_CASTIGO_DATACREDITO_1 has 53215 (15.6%) missing values | Missing |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 has 34599 (10.1%) missing values | Missing |
Contacto__c has unique values | Unique |
PUNTAJE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
INGRESOS_ESTIMADOS_DATACREDITO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
PUNTAJE_1 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
INGRESOS_ESTIMADOS_DATACREDITO_1 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SALDO_CASTIGO_DATACREDITO has 7468 (2.2%) zeros | Zeros |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO has 3979 (1.2%) zeros | Zeros |
CUOTAS_MERCADO_1 has 23662 (6.9%) zeros | Zeros |
SALDO_TOTAL_DATACREDITO_1 has 6494 (1.9%) zeros | Zeros |
BANCOS_CREDITOS_ACTIVOS_1 has 12318 (3.6%) zeros | Zeros |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 has 6720 (2.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-07 04:05:16.550591 |
|---|---|
| Analysis finished | 2025-07-07 04:08:34.330139 |
| Duration | 3 minutes and 17.78 seconds |
| Software version | ydata-profiling vv4.6.2 |
| Download configuration | config.json |
Contacto__c
Text
UNIQUE
| Distinct | 341706 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 27.0 MiB |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Characters and Unicode
| Total characters | 6150708 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 341706 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0036e000043bxo7AAA |
|---|---|
| 2nd row | 0035A00003XlKblQAF |
| 3rd row | 0036e000046v5rCAAQ |
| 4th row | 0035A00003XihQkQAJ |
| 5th row | 0035A00003XihVTQAZ |
| Value | Count | Frequency (%) |
| 0036e000043bxo7aaa | 1 | < 0.1% |
| 0035a00003xihvtqaz | 1 | < 0.1% |
| 0035a00003xlkatqaf | 1 | < 0.1% |
| 0035a00003xihsvqaz | 1 | < 0.1% |
| 0035a00003xihvbqaz | 1 | < 0.1% |
| 0035a00003xihv6qaj | 1 | < 0.1% |
| 0035a00003xihwrqaz | 1 | < 0.1% |
| 0035a00003xlkajqaf | 1 | < 0.1% |
| 0035a00003xlkacqav | 1 | < 0.1% |
| 0036e000046v5sdaaq | 1 | < 0.1% |
| Other values (341696) | 341696 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2091737 | |
| A | 725245 | 11.8% |
| 3 | 658445 | 10.7% |
| 5 | 253870 | 4.1% |
| Q | 197332 | 3.2% |
| 6 | 191605 | 3.1% |
| e | 191517 | 3.1% |
| 4 | 125403 | 2.0% |
| B | 112932 | 1.8% |
| X | 102079 | 1.7% |
| Other values (52) | 1500543 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3464784 | |
| Uppercase Letter | 1792045 | |
| Lowercase Letter | 893879 | 14.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 725245 | |
| Q | 197332 | 11.0% |
| B | 112932 | 6.3% |
| X | 102079 | 5.7% |
| C | 56549 | 3.2% |
| Y | 53666 | 3.0% |
| S | 44653 | 2.5% |
| I | 41319 | 2.3% |
| J | 40947 | 2.3% |
| R | 37226 | 2.1% |
| Other values (16) | 380097 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 191517 | |
| k | 80707 | 9.0% |
| b | 75237 | 8.4% |
| n | 55788 | 6.2% |
| r | 42719 | 4.8% |
| u | 39544 | 4.4% |
| l | 39145 | 4.4% |
| t | 31394 | 3.5% |
| x | 30310 | 3.4% |
| c | 24644 | 2.8% |
| Other values (16) | 282874 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2091737 | |
| 3 | 658445 | 19.0% |
| 5 | 253870 | 7.3% |
| 6 | 191605 | 5.5% |
| 4 | 125403 | 3.6% |
| 9 | 53369 | 1.5% |
| 2 | 32673 | 0.9% |
| 1 | 25495 | 0.7% |
| 8 | 17413 | 0.5% |
| 7 | 14774 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3464784 | |
| Latin | 2685924 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 725245 | |
| Q | 197332 | 7.3% |
| e | 191517 | 7.1% |
| B | 112932 | 4.2% |
| X | 102079 | 3.8% |
| k | 80707 | 3.0% |
| b | 75237 | 2.8% |
| C | 56549 | 2.1% |
| n | 55788 | 2.1% |
| Y | 53666 | 2.0% |
| Other values (42) | 1034872 |
Common
| Value | Count | Frequency (%) |
| 0 | 2091737 | |
| 3 | 658445 | 19.0% |
| 5 | 253870 | 7.3% |
| 6 | 191605 | 5.5% |
| 4 | 125403 | 3.6% |
| 9 | 53369 | 1.5% |
| 2 | 32673 | 0.9% |
| 1 | 25495 | 0.7% |
| 8 | 17413 | 0.5% |
| 7 | 14774 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6150708 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2091737 | |
| A | 725245 | 11.8% |
| 3 | 658445 | 10.7% |
| 5 | 253870 | 4.1% |
| Q | 197332 | 3.2% |
| 6 | 191605 | 3.1% |
| e | 191517 | 3.1% |
| 4 | 125403 | 2.0% |
| B | 112932 | 1.8% |
| X | 102079 | 1.7% |
| Other values (52) | 1500543 |
Entidad_principal
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 MiB |
| BANCO DE BOGOTA | |
|---|---|
| BANCO DE BOGOTA5 | |
| BANCO DE BOGOTA3 | |
| BANCOLOMBIA2 | |
| TUYA2 | |
| Other values (15) |
Length
| Max length | 18 |
|---|---|
| Median length | 17 |
| Mean length | 12.837155 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4386533 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BANCO DE BOGOTA4 |
|---|---|
| 2nd row | GRUPO SOL |
| 3rd row | GRUPO SOL |
| 4th row | GRUPO SOL |
| 5th row | GRUPO SOL |
Common Values
| Value | Count | Frequency (%) |
| BANCO DE BOGOTA | 70343 | |
| BANCO DE BOGOTA5 | 44793 | |
| BANCO DE BOGOTA3 | 36218 | |
| BANCOLOMBIA2 | 34988 | |
| TUYA2 | 28637 | |
| BANCO DE BOGOTA2 | 24782 | 7.3% |
| BANCOLOMBIA | 22373 | 6.5% |
| TUYA | 15454 | 4.5% |
| BANCO DE OCCIDENTE | 14276 | 4.2% |
| BANCAMIA | 12334 | 3.6% |
| Other values (10) | 37508 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| banco | 198138 | |
| de | 198138 | |
| bogota | 70343 | 9.3% |
| bogota5 | 44793 | 5.9% |
| bogota3 | 36218 | 4.8% |
| bancolombia2 | 34988 | 4.6% |
| tuya2 | 28637 | 3.8% |
| bogota2 | 24782 | 3.3% |
| bancolombia | 22373 | 3.0% |
| tuya | 15454 | 2.0% |
| Other values (16) | 82005 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 714832 | |
| A | 627303 | |
| B | 509056 | |
| 414163 | ||
| C | 307084 | |
| N | 300798 | |
| T | 260663 | 5.9% |
| E | 228901 | 5.2% |
| D | 215624 | 4.9% |
| G | 192713 | 4.4% |
| Other values (15) | 615396 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3792995 | |
| Space Separator | 414163 | 9.4% |
| Decimal Number | 179375 | 4.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 714832 | |
| A | 627303 | |
| B | 509056 | |
| C | 307084 | |
| N | 300798 | |
| T | 260663 | 6.9% |
| E | 228901 | 6.0% |
| D | 215624 | 5.7% |
| G | 192713 | 5.1% |
| I | 122379 | 3.2% |
| Other values (10) | 313642 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 90638 | |
| 5 | 44793 | |
| 3 | 36218 | 20.2% |
| 4 | 7726 | 4.3% |
Space Separator
| Value | Count | Frequency (%) |
| 414163 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3792995 | |
| Common | 593538 | 13.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 714832 | |
| A | 627303 | |
| B | 509056 | |
| C | 307084 | |
| N | 300798 | |
| T | 260663 | 6.9% |
| E | 228901 | 6.0% |
| D | 215624 | 5.7% |
| G | 192713 | 5.1% |
| I | 122379 | 3.2% |
| Other values (10) | 313642 |
Common
| Value | Count | Frequency (%) |
| 414163 | ||
| 2 | 90638 | 15.3% |
| 5 | 44793 | 7.5% |
| 3 | 36218 | 6.1% |
| 4 | 7726 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4386533 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 714832 | |
| A | 627303 | |
| B | 509056 | |
| 414163 | ||
| C | 307084 | |
| N | 300798 | |
| T | 260663 | 5.9% |
| E | 228901 | 5.2% |
| D | 215624 | 4.9% |
| G | 192713 | 4.4% |
| Other values (15) | 615396 |
Operado_Por__c
Categorical
HIGH CORRELATION
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.1 MiB |
| DIGITAL | |
|---|---|
| PAZ_SALVO | |
| QNT_RBK_1 | |
| QNT_BB3 | |
| QNT_OS_MONTOSBAJOS | |
| Other values (35) |
Length
| Max length | 34 |
|---|---|
| Median length | 33 |
| Mean length | 8.8938064 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3039067 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AYS_BB4 |
|---|---|
| 2nd row | DIGITAL |
| 3rd row | DIGITAL |
| 4th row | DIGITAL |
| 5th row | DIGITAL |
Common Values
| Value | Count | Frequency (%) |
| DIGITAL | 102600 | |
| PAZ_SALVO | 49062 | |
| QNT_RBK_1 | 27275 | 8.0% |
| QNT_BB3 | 20521 | 6.0% |
| QNT_OS_MONTOSBAJOS | 16947 | 5.0% |
| QNT_RBK_2 | 15969 | 4.7% |
| CX_RBK | 8931 | 2.6% |
| QNT_OCC | 7742 | 2.3% |
| NEXTDATA_BB5_JUD | 7508 | 2.2% |
| CX_BB5_JUD | 7227 | 2.1% |
| Other values (30) | 77924 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| digital | 102600 | |
| paz_salvo | 49062 | |
| qnt_rbk_1 | 27275 | 8.0% |
| qnt_bb3 | 20521 | 6.0% |
| qnt_os_montosbajos | 16947 | 5.0% |
| qnt_rbk_2 | 15969 | 4.7% |
| cx_rbk | 8931 | 2.6% |
| qnt_occ | 7742 | 2.3% |
| nextdata_bb5_jud | 7508 | 2.2% |
| cx_bb5_jud | 7227 | 2.1% |
| Other values (30) | 77924 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 306088 | 10.1% |
| _ | 293568 | 9.7% |
| T | 281806 | 9.3% |
| I | 230962 | 7.6% |
| B | 196421 | 6.5% |
| O | 178144 | 5.9% |
| N | 176341 | 5.8% |
| D | 164064 | 5.4% |
| L | 158534 | 5.2% |
| S | 131533 | 4.3% |
| Other values (22) | 921606 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2621717 | |
| Connector Punctuation | 293568 | 9.7% |
| Decimal Number | 103364 | 3.4% |
| Lowercase Letter | 10211 | 0.3% |
| Dash Punctuation | 10207 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 306088 | |
| T | 281806 | |
| I | 230962 | 8.8% |
| B | 196421 | 7.5% |
| O | 178144 | 6.8% |
| N | 176341 | 6.7% |
| D | 164064 | 6.3% |
| L | 158534 | 6.0% |
| S | 131533 | 5.0% |
| G | 106498 | 4.1% |
| Other values (14) | 691326 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 29922 | |
| 1 | 27275 | |
| 2 | 20909 | |
| 3 | 20521 | |
| 4 | 4737 | 4.6% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 293568 |
Lowercase Letter
| Value | Count | Frequency (%) |
| y | 10211 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10207 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2631928 | |
| Common | 407139 | 13.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 306088 | |
| T | 281806 | |
| I | 230962 | 8.8% |
| B | 196421 | 7.5% |
| O | 178144 | 6.8% |
| N | 176341 | 6.7% |
| D | 164064 | 6.2% |
| L | 158534 | 6.0% |
| S | 131533 | 5.0% |
| G | 106498 | 4.0% |
| Other values (15) | 701537 |
Common
| Value | Count | Frequency (%) |
| _ | 293568 | |
| 5 | 29922 | 7.3% |
| 1 | 27275 | 6.7% |
| 2 | 20909 | 5.1% |
| 3 | 20521 | 5.0% |
| - | 10207 | 2.5% |
| 4 | 4737 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3039067 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 306088 | 10.1% |
| _ | 293568 | 9.7% |
| T | 281806 | 9.3% |
| I | 230962 | 7.6% |
| B | 196421 | 6.5% |
| O | 178144 | 5.9% |
| N | 176341 | 5.8% |
| D | 164064 | 5.4% |
| L | 158534 | 5.2% |
| S | 131533 | 4.3% |
| Other values (22) | 921606 |
Saldo_Capital_cliente
Real number (ℝ)
HIGH CORRELATION
| Distinct | 326011 |
|---|---|
| Distinct (%) | 95.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6137716.5 |
| Minimum | 0 |
|---|---|
| Maximum | 6.6418115 × 108 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 492551.25 |
| Q1 | 1189304.2 |
| median | 3014919.5 |
| Q3 | 6866761.5 |
| 95-th percentile | 22541596 |
| Maximum | 6.6418115 × 108 |
| Range | 6.6418115 × 108 |
| Interquartile range (IQR) | 5677457.2 |
Descriptive statistics
| Standard deviation | 9962015.4 |
|---|---|
| Coefficient of variation (CV) | 1.6230817 |
| Kurtosis | 174.96326 |
| Mean | 6137716.5 |
| Median Absolute Deviation (MAD) | 2113175.5 |
| Skewness | 7.3004448 |
| Sum | 2.0972946 × 1012 |
| Variance | 9.9241751 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 120000 | 385 | 0.1% |
| 500000 | 378 | 0.1% |
| 1242090 | 363 | 0.1% |
| 700000 | 287 | 0.1% |
| 1242174 | 281 | 0.1% |
| 600000 | 252 | 0.1% |
| 300000 | 245 | 0.1% |
| 1000000 | 240 | 0.1% |
| 800000 | 195 | 0.1% |
| 110794 | 195 | 0.1% |
| Other values (326001) | 338885 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 1 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 142 | 1 | < 0.1% |
| 1184 | 1 | < 0.1% |
| 1223 | 1 | < 0.1% |
| 1550 | 1 | < 0.1% |
| 1574 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 664181151 | 1 | |
| 591158586 | 1 | |
| 538210981 | 1 | |
| 364155789 | 1 | |
| 321284333 | 1 | |
| 270142033 | 1 | |
| 269070589 | 1 | |
| 253775674 | 1 | |
| 253743212 | 1 | |
| 253594853 | 1 |
Saldo_Total_cliente
Real number (ℝ)
HIGH CORRELATION
| Distinct | 336919 |
|---|---|
| Distinct (%) | 98.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18954263 |
| Minimum | 0 |
|---|---|
| Maximum | 6.0148234 × 109 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 829167.25 |
| Q1 | 2179316.8 |
| median | 5266021 |
| Q3 | 13541606 |
| 95-th percentile | 86063904 |
| Maximum | 6.0148234 × 109 |
| Range | 6.0148234 × 109 |
| Interquartile range (IQR) | 11362290 |
Descriptive statistics
| Standard deviation | 51381643 |
|---|---|
| Coefficient of variation (CV) | 2.7108226 |
| Kurtosis | 927.19485 |
| Mean | 18954263 |
| Median Absolute Deviation (MAD) | 3743200 |
| Skewness | 15.766182 |
| Sum | 6.4767852 × 1012 |
| Variance | 2.6400732 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 646522 | 59 | < 0.1% |
| 608572 | 21 | < 0.1% |
| 598222 | 19 | < 0.1% |
| 151690 | 18 | < 0.1% |
| 441450 | 14 | < 0.1% |
| 862029 | 12 | < 0.1% |
| 592644 | 11 | < 0.1% |
| 152345 | 10 | < 0.1% |
| 910956 | 10 | < 0.1% |
| 587872 | 9 | < 0.1% |
| Other values (336909) | 341523 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 2 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| 161 | 1 | < 0.1% |
| 1415 | 1 | < 0.1% |
| 1603 | 1 | < 0.1% |
| 1773 | 1 | < 0.1% |
| 1871 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6014823401 | 1 | |
| 4245160770 | 1 | |
| 4000141911 | 1 | |
| 2382531777 | 1 | |
| 2313937771 | 1 | |
| 2038192840 | 1 | |
| 2032587733 | 1 | |
| 2013072612 | 1 | |
| 1762674417 | 1 | |
| 1751234918 | 1 |
Edad__c
Real number (ℝ)
HIGH CORRELATION
| Distinct | 83 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 23 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.194815 |
| Minimum | 0 |
|---|---|
| Maximum | 158 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 35 |
| median | 41 |
| Q3 | 51 |
| 95-th percentile | 61 |
| Maximum | 158 |
| Range | 158 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 14.789317 |
|---|---|
| Coefficient of variation (CV) | 0.35050082 |
| Kurtosis | 8.2916736 |
| Mean | 42.194815 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 1.3485555 |
| Sum | 14417251 |
| Variance | 218.7239 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 44 | 34939 | 10.2% |
| 37 | 31870 | 9.3% |
| 41 | 27775 | 8.1% |
| 42 | 24934 | 7.3% |
| 51 | 20656 | 6.0% |
| 54 | 20624 | 6.0% |
| 35 | 20064 | 5.9% |
| 34 | 19682 | 5.8% |
| 61 | 19546 | 5.7% |
| 29 | 17944 | 5.3% |
| Other values (73) | 103649 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1 | 1549 | 0.5% |
| 2 | 6635 | |
| 3 | 157 | < 0.1% |
| 7 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 21 | 109 | < 0.1% |
| 22 | 161 | < 0.1% |
| Value | Count | Frequency (%) |
| 158 | 1 | < 0.1% |
| 154 | 1 | < 0.1% |
| 153 | 1 | < 0.1% |
| 148 | 1 | < 0.1% |
| 135 | 1 | < 0.1% |
| 123 | 1 | < 0.1% |
| 122 | 3713 | |
| 90 | 1 | < 0.1% |
| 88 | 1 | < 0.1% |
| 86 | 1 | < 0.1% |
Genero__c
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.5 MiB |
| M | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 341706 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 195676 | |
| F | 146030 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 195676 | |
| f | 146030 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 195676 | |
| F | 146030 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 341706 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 195676 | |
| F | 146030 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 341706 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 195676 | |
| F | 146030 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 341706 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 195676 | |
| F | 146030 |
Ciudad
Text
| Distinct | 949 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 128 |
| Missing (%) | < 0.1% |
| Memory size | 24.3 MiB |
Length
| Max length | 27 |
|---|---|
| Median length | 23 |
| Mean length | 9.5071814 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3247444 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SIN INFORMACION |
|---|---|
| 2nd row | SIN INFORMACION |
| 3rd row | SIN INFORMACION |
| 4th row | SIN INFORMACION |
| 5th row | SIN INFORMACION |
| Value | Count | Frequency (%) |
| bogota | 101400 | |
| d.c | 101400 | |
| sin | 32507 | 6.5% |
| informacion | 32507 | 6.5% |
| cali | 32352 | 6.5% |
| medellin | 15141 | 3.0% |
| barranquilla | 12937 | 2.6% |
| bucaramanga | 7875 | 1.6% |
| cartagena | 7415 | 1.5% |
| cucuta | 5592 | 1.1% |
| Other values (937) | 149663 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 466259 | |
| O | 339866 | 10.5% |
| I | 245076 | 7.5% |
| C | 243705 | 7.5% |
| . | 202800 | 6.2% |
| N | 202372 | 6.2% |
| 157211 | 4.8% | |
| T | 155345 | 4.8% |
| L | 152850 | 4.7% |
| B | 150893 | 4.6% |
| Other values (20) | 931067 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2886579 | |
| Other Punctuation | 202800 | 6.2% |
| Space Separator | 157211 | 4.8% |
| Initial Punctuation | 828 | < 0.1% |
| Lowercase Letter | 19 | < 0.1% |
| Control | 7 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 466259 | |
| O | 339866 | |
| I | 245076 | 8.5% |
| C | 243705 | 8.4% |
| N | 202372 | 7.0% |
| T | 155345 | 5.4% |
| L | 152850 | 5.3% |
| B | 150893 | 5.2% |
| D | 150555 | 5.2% |
| G | 141928 | 4.9% |
| Other values (15) | 637730 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 202800 |
Space Separator
| Value | Count | Frequency (%) |
| 157211 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 828 |
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 19 |
Control
| Value | Count | Frequency (%) |
| | 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2886598 | |
| Common | 360846 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 466259 | |
| O | 339866 | |
| I | 245076 | 8.5% |
| C | 243705 | 8.4% |
| N | 202372 | 7.0% |
| T | 155345 | 5.4% |
| L | 152850 | 5.3% |
| B | 150893 | 5.2% |
| D | 150555 | 5.2% |
| G | 141928 | 4.9% |
| Other values (16) | 637749 |
Common
| Value | Count | Frequency (%) |
| . | 202800 | |
| 157211 | ||
| ‘ | 828 | 0.2% |
| | 7 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3245774 | |
| None | 842 | < 0.1% |
| Punctuation | 828 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 466259 | |
| O | 339866 | 10.5% |
| I | 245076 | 7.6% |
| C | 243705 | 7.5% |
| . | 202800 | 6.2% |
| N | 202372 | 6.2% |
| 157211 | 4.8% | |
| T | 155345 | 4.8% |
| L | 152850 | 4.7% |
| B | 150893 | 4.6% |
| Other values (17) | 929397 |
None
| Value | Count | Frequency (%) |
| Ã | 835 | |
| | 7 | 0.8% |
Punctuation
| Value | Count | Frequency (%) |
| ‘ | 828 |
estado
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 512 |
| Missing (%) | 0.1% |
| Memory size | 25.4 MiB |
| POR_CONTACTAR | |
|---|---|
| MANTENIMIENTO | |
| POR_ACORDAR | 19213 |
| POR_PAGAR | 1115 |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.874306 |
| Min length | 9 |
Characters and Unicode
| Total characters | 4392636 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | POR_ACORDAR |
|---|---|
| 2nd row | POR_ACORDAR |
| 3rd row | MANTENIMIENTO |
| 4th row | MANTENIMIENTO |
| 5th row | MANTENIMIENTO |
Common Values
| Value | Count | Frequency (%) |
| POR_CONTACTAR | 255647 | |
| MANTENIMIENTO | 65219 | 19.1% |
| POR_ACORDAR | 19213 | 5.6% |
| POR_PAGAR | 1115 | 0.3% |
| (Missing) | 512 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| por_contactar | 255647 | |
| mantenimiento | 65219 | 19.1% |
| por_acordar | 19213 | 5.6% |
| por_pagar | 1115 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 641732 | |
| A | 617169 | |
| O | 616054 | |
| R | 571163 | |
| C | 530507 | |
| N | 451304 | |
| P | 277090 | |
| _ | 275975 | |
| M | 130438 | 3.0% |
| E | 130438 | 3.0% |
| Other values (3) | 150766 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4116661 | |
| Connector Punctuation | 275975 | 6.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 641732 | |
| A | 617169 | |
| O | 616054 | |
| R | 571163 | |
| C | 530507 | |
| N | 451304 | |
| P | 277090 | |
| M | 130438 | 3.2% |
| E | 130438 | 3.2% |
| I | 130438 | 3.2% |
| Other values (2) | 20328 | 0.5% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 275975 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4116661 | |
| Common | 275975 | 6.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 641732 | |
| A | 617169 | |
| O | 616054 | |
| R | 571163 | |
| C | 530507 | |
| N | 451304 | |
| P | 277090 | |
| M | 130438 | 3.2% |
| E | 130438 | 3.2% |
| I | 130438 | 3.2% |
| Other values (2) | 20328 | 0.5% |
Common
| Value | Count | Frequency (%) |
| _ | 275975 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4392636 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 641732 | |
| A | 617169 | |
| O | 616054 | |
| R | 571163 | |
| C | 530507 | |
| N | 451304 | |
| P | 277090 | |
| _ | 275975 | |
| M | 130438 | 3.0% |
| E | 130438 | 3.0% |
| Other values (3) | 150766 | 3.4% |
localizado_historico
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 516 |
| Missing (%) | 0.2% |
| Memory size | 25.1 MiB |
| NO_LOCALIZADO | |
|---|---|
| LOCALIZADO |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 11.97087 |
| Min length | 10 |
Characters and Unicode
| Total characters | 4084341 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LOCALIZADO |
|---|---|
| 2nd row | LOCALIZADO |
| 3rd row | LOCALIZADO |
| 4th row | LOCALIZADO |
| 5th row | LOCALIZADO |
Common Values
| Value | Count | Frequency (%) |
| NO_LOCALIZADO | 224147 | |
| LOCALIZADO | 117043 | |
| (Missing) | 516 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no_localizado | 224147 | |
| localizado | 117043 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 906527 | |
| L | 682380 | |
| A | 682380 | |
| C | 341190 | 8.4% |
| I | 341190 | 8.4% |
| Z | 341190 | 8.4% |
| D | 341190 | 8.4% |
| N | 224147 | 5.5% |
| _ | 224147 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3860194 | |
| Connector Punctuation | 224147 | 5.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 906527 | |
| L | 682380 | |
| A | 682380 | |
| C | 341190 | 8.8% |
| I | 341190 | 8.8% |
| Z | 341190 | 8.8% |
| D | 341190 | 8.8% |
| N | 224147 | 5.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 224147 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3860194 | |
| Common | 224147 | 5.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 906527 | |
| L | 682380 | |
| A | 682380 | |
| C | 341190 | 8.8% |
| I | 341190 | 8.8% |
| Z | 341190 | 8.8% |
| D | 341190 | 8.8% |
| N | 224147 | 5.8% |
Common
| Value | Count | Frequency (%) |
| _ | 224147 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4084341 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 906527 | |
| L | 682380 | |
| A | 682380 | |
| C | 341190 | 8.4% |
| I | 341190 | 8.4% |
| Z | 341190 | 8.4% |
| D | 341190 | 8.4% |
| N | 224147 | 5.5% |
| _ | 224147 | 5.5% |
Motivo_Renuencia_Cliente
Categorical
HIGH CORRELATION
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 368 |
| Missing (%) | 0.1% |
| Memory size | 32.8 MiB |
| CLIENTE SIN NINGUN CONTACTO HISTORICO | |
|---|---|
| CLIENTE CANCELADO | |
| CLIENTE PERDIDO | |
| CLIENTE NO PERDIDO QUIEN NO ACEPTA POR DIVERSOS MOTIVOS | |
| CLIENTE NO PERDIDO QUIEN CUELGA ANTE EL OFRECIMIENTO | |
| Other values (4) |
Length
| Max length | 56 |
|---|---|
| Median length | 55 |
| Mean length | 35.643503 |
| Min length | 15 |
Characters and Unicode
| Total characters | 12166482 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLIENTE NO PERDIDO QUIEN NO ACEPTA POR DIVERSOS MOTIVOS |
|---|---|
| 2nd row | CLIENTE PERDIDO |
| 3rd row | CLIENTE PERDIDO |
| 4th row | CLIENTE PERDIDO |
| 5th row | CLIENTE PERDIDO |
Common Values
| Value | Count | Frequency (%) |
| CLIENTE SIN NINGUN CONTACTO HISTORICO | 167826 | |
| CLIENTE CANCELADO | 51022 | 14.9% |
| CLIENTE PERDIDO | 28182 | 8.2% |
| CLIENTE NO PERDIDO QUIEN NO ACEPTA POR DIVERSOS MOTIVOS | 25968 | 7.6% |
| CLIENTE NO PERDIDO QUIEN CUELGA ANTE EL OFRECIMIENTO | 21906 | 6.4% |
| CLIENTE NO PERDIDO QUIEN NO ACEPTA POR CAPACIDAD DE PAGO | 14315 | 4.2% |
| CLIENTE CON ALGUN PAGO HISTORICO | 13951 | 4.1% |
| CLIENTE NO PERDIDO QUIEN NO ACEPTA POR EMPLEO | 13939 | 4.1% |
| CLIENTE NO PERDIDO QUIEN REITERA EXCUSAS DE TODO TIPO | 4229 | 1.2% |
| (Missing) | 368 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| cliente | 341338 | |
| historico | 181777 | |
| ningun | 167826 | |
| contacto | 167826 | |
| sin | 167826 | |
| no | 134579 | 7.6% |
| perdido | 108539 | 6.1% |
| quien | 80357 | 4.5% |
| acepta | 54222 | 3.1% |
| por | 54222 | 3.1% |
| Other values (17) | 310464 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 1518140 | |
| 1427638 | ||
| I | 1347961 | |
| O | 1238127 | |
| E | 1171423 | |
| C | 1105655 | |
| T | 995456 | |
| A | 515746 | 4.2% |
| L | 464062 | 3.8% |
| S | 435965 | 3.6% |
| Other values (11) | 1946309 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10738844 | |
| Space Separator | 1427638 | 11.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1518140 | |
| I | 1347961 | |
| O | 1238127 | |
| E | 1171423 | |
| C | 1105655 | |
| T | 995456 | |
| A | 515746 | 4.8% |
| L | 464062 | 4.3% |
| S | 435965 | 4.1% |
| R | 400870 | 3.7% |
| Other values (10) | 1545439 |
Space Separator
| Value | Count | Frequency (%) |
| 1427638 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10738844 | |
| Common | 1427638 | 11.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1518140 | |
| I | 1347961 | |
| O | 1238127 | |
| E | 1171423 | |
| C | 1105655 | |
| T | 995456 | |
| A | 515746 | 4.8% |
| L | 464062 | 4.3% |
| S | 435965 | 4.1% |
| R | 400870 | 3.7% |
| Other values (10) | 1545439 |
Common
| Value | Count | Frequency (%) |
| 1427638 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12166482 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 1518140 | |
| 1427638 | ||
| I | 1347961 | |
| O | 1238127 | |
| E | 1171423 | |
| C | 1105655 | |
| T | 995456 | |
| A | 515746 | 4.2% |
| L | 464062 | 3.8% |
| S | 435965 | 3.6% |
| Other values (11) | 1946309 |
RANGO_EDAD
Categorical
HIGH CORRELATION MISSING
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9533 |
| Missing (%) | 2.8% |
| Memory size | 22.6 MiB |
| 36-45 | |
|---|---|
| 29-35 | |
| 46-55 | |
| 22-28 | |
| 56-65 | |
| Other values (4) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.9572994 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1646681 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 29-35 |
|---|---|
| 2nd row | 36-45 |
| 3rd row | 56-65 |
| 4th row | 66+ |
| 5th row | 56-65 |
Common Values
| Value | Count | Frequency (%) |
| 36-45 | 99419 | |
| 29-35 | 84050 | |
| 46-55 | 63976 | |
| 22-28 | 52035 | |
| 56-65 | 22616 | 6.6% |
| 66+ | 7092 | 2.1% |
| 18-21 | 2648 | 0.8% |
| 66+ | 329 | 0.1% |
| 8 | < 0.1% | |
| (Missing) | 9533 | 2.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 36-45 | 99419 | |
| 29-35 | 84050 | |
| 46-55 | 63976 | |
| 22-28 | 52035 | |
| 56-65 | 22616 | 6.8% |
| 66 | 7421 | 2.2% |
| 18-21 | 2648 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 356653 | |
| - | 324744 | |
| 2 | 242803 | |
| 6 | 223469 | |
| 3 | 183469 | |
| 4 | 163395 | |
| 9 | 84050 | 5.1% |
| 8 | 54683 | 3.3% |
| + | 7421 | 0.5% |
| 1 | 5296 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1313818 | |
| Dash Punctuation | 324744 | 19.7% |
| Math Symbol | 7421 | 0.5% |
| Space Separator | 698 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 356653 | |
| 2 | 242803 | |
| 6 | 223469 | |
| 3 | 183469 | |
| 4 | 163395 | |
| 9 | 84050 | 6.4% |
| 8 | 54683 | 4.2% |
| 1 | 5296 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 324744 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 7421 |
Space Separator
| Value | Count | Frequency (%) |
| 698 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1646681 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 356653 | |
| - | 324744 | |
| 2 | 242803 | |
| 6 | 223469 | |
| 3 | 183469 | |
| 4 | 163395 | |
| 9 | 84050 | 5.1% |
| 8 | 54683 | 3.3% |
| + | 7421 | 0.5% |
| 1 | 5296 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1646681 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 356653 | |
| - | 324744 | |
| 2 | 242803 | |
| 6 | 223469 | |
| 3 | 183469 | |
| 4 | 163395 | |
| 9 | 84050 | 5.1% |
| 8 | 54683 | 3.3% |
| + | 7421 | 0.5% |
| 1 | 5296 | 0.3% |
FECHA_RECEPCION
Date
| Distinct | 85 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2664 |
| Missing (%) | 0.8% |
| Memory size | 5.2 MiB |
| Minimum | 2018-10-23 00:00:00+00:00 |
|---|---|
| Maximum | 2022-07-22 00:00:00+00:00 |
Histogram with fixed size bins (bins=50)
PUNTAJE
Unsupported
REJECTED UNSUPPORTED
| Missing | 2786 |
|---|---|
| Missing (%) | 0.8% |
| Memory size | 24.0 MiB |
INGRESOS_ESTIMADOS_DATACREDITO
Unsupported
REJECTED UNSUPPORTED
| Missing | 2795 |
|---|---|
| Missing (%) | 0.8% |
| Memory size | 23.9 MiB |
SALDO_TOTAL_DATACREDITO
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 81476 |
|---|---|
| Distinct (%) | 24.4% |
| Missing | 8327 |
| Missing (%) | 2.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26293.937 |
| Minimum | 0 |
|---|---|
| Maximum | 5249551 |
| Zeros | 1864 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1079 |
| Q1 | 3960 |
| median | 11103 |
| Q3 | 28090.5 |
| 95-th percentile | 96498.5 |
| Maximum | 5249551 |
| Range | 5249551 |
| Interquartile range (IQR) | 24130.5 |
Descriptive statistics
| Standard deviation | 55241.755 |
|---|---|
| Coefficient of variation (CV) | 2.1009313 |
| Kurtosis | 579.3076 |
| Mean | 26293.937 |
| Median Absolute Deviation (MAD) | 8596 |
| Skewness | 14.244172 |
| Sum | 8.7658464 × 109 |
| Variance | 3.0516515 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1864 | 0.5% |
| 1878 | 45 | < 0.1% |
| 1808 | 44 | < 0.1% |
| 124 | 44 | < 0.1% |
| 1629 | 42 | < 0.1% |
| 1807 | 42 | < 0.1% |
| 2145 | 42 | < 0.1% |
| 1665 | 41 | < 0.1% |
| 2168 | 41 | < 0.1% |
| 1679 | 40 | < 0.1% |
| Other values (81466) | 331134 | |
| (Missing) | 8327 | 2.4% |
| Value | Count | Frequency (%) |
| 0 | 1864 | |
| 1 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5249551 | 1 | |
| 4122696 | 1 | |
| 2807356 | 1 | |
| 2741651 | 1 | |
| 2645058 | 1 | |
| 2578617 | 1 | |
| 2538955 | 1 | |
| 2372671 | 1 | |
| 2084091 | 1 | |
| 2041891 | 1 |
SALDO_CASTIGO_DATACREDITO
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 68216 |
|---|---|
| Distinct (%) | 20.5% |
| Missing | 8747 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19126.325 |
| Minimum | 0 |
|---|---|
| Maximum | 4088234 |
| Zeros | 7468 |
| Zeros (%) | 2.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 624 |
| Q1 | 2622 |
| median | 7753 |
| Q3 | 19954.5 |
| 95-th percentile | 72533.1 |
| Maximum | 4088234 |
| Range | 4088234 |
| Interquartile range (IQR) | 17332.5 |
Descriptive statistics
| Standard deviation | 40624.973 |
|---|---|
| Coefficient of variation (CV) | 2.1240344 |
| Kurtosis | 535.04942 |
| Mean | 19126.325 |
| Median Absolute Deviation (MAD) | 6104 |
| Skewness | 13.160798 |
| Sum | 6.3682822 × 109 |
| Variance | 1.6503884 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7468 | 2.2% |
| 124 | 126 | < 0.1% |
| 123 | 90 | < 0.1% |
| 125 | 87 | < 0.1% |
| 700 | 80 | < 0.1% |
| 500 | 73 | < 0.1% |
| 600 | 61 | < 0.1% |
| 599 | 61 | < 0.1% |
| 800 | 60 | < 0.1% |
| 1000 | 59 | < 0.1% |
| Other values (68206) | 324794 | |
| (Missing) | 8747 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 7468 | |
| 2 | 3 | < 0.1% |
| 5 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 13 | 2 | < 0.1% |
| 14 | 3 | < 0.1% |
| 16 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4088234 | 1 | |
| 1984343 | 1 | |
| 1950637 | 1 | |
| 1947521 | 1 | |
| 1856787 | 1 | |
| 1788418 | 1 | |
| 1762018 | 1 | |
| 1580489 | 1 | |
| 1576184 | 1 | |
| 1534371 | 1 |
BANCOS_CREDITOS_ACTIVOS
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 13793 |
| Missing (%) | 4.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7830461 |
| Minimum | 0 |
|---|---|
| Maximum | 34 |
| Zeros | 2169 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.0279866 |
|---|---|
| Coefficient of variation (CV) | 0.72869315 |
| Kurtosis | 4.0653916 |
| Mean | 2.7830461 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.6504155 |
| Sum | 912597 |
| Variance | 4.1127298 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=27)
| Value | Count | Frequency (%) |
| 1 | 104400 | |
| 2 | 78850 | |
| 3 | 52705 | |
| 4 | 34194 | 10.0% |
| 5 | 22310 | 6.5% |
| 6 | 13871 | 4.1% |
| 7 | 8367 | 2.4% |
| 8 | 4926 | 1.4% |
| 9 | 2753 | 0.8% |
| 0 | 2169 | 0.6% |
| Other values (17) | 3368 | 1.0% |
| (Missing) | 13793 | 4.0% |
| Value | Count | Frequency (%) |
| 0 | 2169 | 0.6% |
| 1 | 104400 | |
| 2 | 78850 | |
| 3 | 52705 | |
| 4 | 34194 | 10.0% |
| 5 | 22310 | 6.5% |
| 6 | 13871 | 4.1% |
| 7 | 8367 | 2.4% |
| 8 | 4926 | 1.4% |
| 9 | 2753 | 0.8% |
| Value | Count | Frequency (%) |
| 34 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 25 | 2 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 6 | < 0.1% |
| 21 | 3 | < 0.1% |
| 20 | 7 | < 0.1% |
| 19 | 10 | |
| 18 | 15 | |
| 17 | 19 |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 144278 |
|---|---|
| Distinct (%) | 43.3% |
| Missing | 8489 |
| Missing (%) | 2.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8786993 |
| Minimum | -0.077785564 |
|---|---|
| Maximum | 3.2288855 |
| Zeros | 3979 |
| Zeros (%) | 1.2% |
| Negative | 20 |
| Negative (%) | < 0.1% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | -0.077785564 |
|---|---|
| 5-th percentile | 0.23379529 |
| Q1 | 0.90775458 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 3.2288855 |
| Range | 3.306671 |
| Interquartile range (IQR) | 0.09224542 |
Descriptive statistics
| Standard deviation | 0.24419099 |
|---|---|
| Coefficient of variation (CV) | 0.27790051 |
| Kurtosis | 3.8709654 |
| Mean | 0.8786993 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.1985251 |
| Sum | 292797.54 |
| Variance | 0.059629237 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 183342 | |
| 0 | 3979 | 1.2% |
| 0.9411764706 | 10 | < 0.1% |
| 0.5 | 9 | < 0.1% |
| 0.8 | 9 | < 0.1% |
| 0.6666666667 | 8 | < 0.1% |
| 0.972972973 | 7 | < 0.1% |
| 0.9565217391 | 7 | < 0.1% |
| 0.875 | 7 | < 0.1% |
| 0.9756097561 | 6 | < 0.1% |
| Other values (144268) | 145833 | |
| (Missing) | 8489 | 2.5% |
| Value | Count | Frequency (%) |
| -0.07778556412 | 1 | |
| -0.07655172414 | 1 | |
| -0.07607950651 | 1 | |
| -0.04926764314 | 1 | |
| -0.03693843594 | 1 | |
| -0.01614545455 | 1 | |
| -0.01143858203 | 1 | |
| -0.01091874877 | 1 | |
| -0.01041471195 | 1 | |
| -0.007597535934 | 1 |
| Value | Count | Frequency (%) |
| 3.228885461 | 1 | |
| 3.000393109 | 1 | |
| 1.968020595 | 1 | |
| 1.437936554 | 1 | |
| 1.428925108 | 1 | |
| 1.413683016 | 1 | |
| 1.402985075 | 1 | |
| 1.237114907 | 1 | |
| 1.236824158 | 1 | |
| 1.227737779 | 1 |
RANGO_EDAD_1
Categorical
HIGH CORRELATION MISSING
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3722 |
| Missing (%) | 1.1% |
| Memory size | 22.7 MiB |
| 36-45 | |
|---|---|
| 29-35 | |
| 46-55 | |
| 56-65 | |
| 22-28 | |
| Other values (3) | 8746 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.9544594 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1674528 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 36-45 |
|---|---|
| 2nd row | 36-45 |
| 3rd row | 56-65 |
| 4th row | 66+ |
| 5th row | 56-65 |
Common Values
| Value | Count | Frequency (%) |
| 36-45 | 107608 | |
| 29-35 | 81646 | |
| 46-55 | 72221 | |
| 56-65 | 35147 | 10.3% |
| 22-28 | 32616 | 9.5% |
| 66+ | 7696 | 2.3% |
| 18-21 | 1046 | 0.3% |
| 66+ | 4 | < 0.1% |
| (Missing) | 3722 | 1.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 36-45 | 107608 | |
| 29-35 | 81646 | |
| 46-55 | 72221 | |
| 56-65 | 35147 | 10.4% |
| 22-28 | 32616 | 9.7% |
| 66 | 7700 | 2.3% |
| 18-21 | 1046 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 403990 | |
| - | 330284 | |
| 6 | 265523 | |
| 3 | 189254 | |
| 2 | 180540 | |
| 4 | 179829 | |
| 9 | 81646 | 4.9% |
| 8 | 33662 | 2.0% |
| + | 7700 | 0.5% |
| 1 | 2092 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1336536 | |
| Dash Punctuation | 330284 | 19.7% |
| Math Symbol | 7700 | 0.5% |
| Space Separator | 8 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 403990 | |
| 6 | 265523 | |
| 3 | 189254 | |
| 2 | 180540 | |
| 4 | 179829 | |
| 9 | 81646 | 6.1% |
| 8 | 33662 | 2.5% |
| 1 | 2092 | 0.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 330284 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 7700 |
Space Separator
| Value | Count | Frequency (%) |
| 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1674528 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 403990 | |
| - | 330284 | |
| 6 | 265523 | |
| 3 | 189254 | |
| 2 | 180540 | |
| 4 | 179829 | |
| 9 | 81646 | 4.9% |
| 8 | 33662 | 2.0% |
| + | 7700 | 0.5% |
| 1 | 2092 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1674528 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 403990 | |
| - | 330284 | |
| 6 | 265523 | |
| 3 | 189254 | |
| 2 | 180540 | |
| 4 | 179829 | |
| 9 | 81646 | 4.9% |
| 8 | 33662 | 2.0% |
| + | 7700 | 0.5% |
| 1 | 2092 | 0.1% |
| Distinct | 86 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2664 |
| Missing (%) | 0.8% |
| Memory size | 5.2 MiB |
| Minimum | 2018-10-23 00:00:00+00:00 |
|---|---|
| Maximum | 2022-07-22 00:00:00+00:00 |
Histogram with fixed size bins (bins=50)
PUNTAJE_1
Unsupported
REJECTED UNSUPPORTED
| Missing | 3015 |
|---|---|
| Missing (%) | 0.9% |
| Memory size | 24.2 MiB |
INGRESOS_ESTIMADOS_DATACREDITO_1
Unsupported
REJECTED UNSUPPORTED
| Missing | 3022 |
|---|---|
| Missing (%) | 0.9% |
| Memory size | 24.7 MiB |
CUOTAS_MERCADO_1
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 65232 |
|---|---|
| Distinct (%) | 19.3% |
| Missing | 3538 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17092.774 |
| Minimum | 0 |
|---|---|
| Maximum | 3265199 |
| Zeros | 23662 |
| Zeros (%) | 6.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1351 |
| median | 4873 |
| Q3 | 14857.25 |
| 95-th percentile | 76291.55 |
| Maximum | 3265199 |
| Range | 3265199 |
| Interquartile range (IQR) | 13506.25 |
Descriptive statistics
| Standard deviation | 40021.803 |
|---|---|
| Coefficient of variation (CV) | 2.3414457 |
| Kurtosis | 224.57521 |
| Mean | 17092.774 |
| Median Absolute Deviation (MAD) | 4408 |
| Skewness | 8.6157114 |
| Sum | 5.7802292 × 109 |
| Variance | 1.6017447 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 23662 | 6.9% |
| 61 | 259 | 0.1% |
| 34 | 214 | 0.1% |
| 75 | 193 | 0.1% |
| 99 | 180 | 0.1% |
| 27 | 171 | 0.1% |
| 30 | 169 | < 0.1% |
| 113 | 169 | < 0.1% |
| 40 | 157 | < 0.1% |
| 100 | 156 | < 0.1% |
| Other values (65222) | 312838 | |
| (Missing) | 3538 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 23662 | |
| 1 | 42 | < 0.1% |
| 2 | 21 | < 0.1% |
| 3 | 17 | < 0.1% |
| 4 | 10 | < 0.1% |
| 5 | 14 | < 0.1% |
| 6 | 7 | < 0.1% |
| 7 | 13 | < 0.1% |
| 8 | 20 | < 0.1% |
| 9 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 3265199 | 1 | |
| 1538662 | 1 | |
| 1449466 | 1 | |
| 1391937 | 1 | |
| 1376518 | 1 | |
| 1314853 | 1 | |
| 1252058 | 1 | |
| 1181279 | 1 | |
| 1146368 | 1 | |
| 1106267 | 1 |
SALDO_TOTAL_DATACREDITO_1
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 81784 |
|---|---|
| Distinct (%) | 25.1% |
| Missing | 15231 |
| Missing (%) | 4.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26125.492 |
| Minimum | 0 |
|---|---|
| Maximum | 4070959 |
| Zeros | 6494 |
| Zeros (%) | 1.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 311 |
| Q1 | 2819 |
| median | 8670 |
| Q3 | 26282 |
| 95-th percentile | 108975.5 |
| Maximum | 4070959 |
| Range | 4070959 |
| Interquartile range (IQR) | 23463 |
Descriptive statistics
| Standard deviation | 56003.243 |
|---|---|
| Coefficient of variation (CV) | 2.1436245 |
| Kurtosis | 431.41282 |
| Mean | 26125.492 |
| Median Absolute Deviation (MAD) | 7216 |
| Skewness | 11.927985 |
| Sum | 8.5293199 × 109 |
| Variance | 3.1363632 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6494 | 1.9% |
| 44 | 94 | < 0.1% |
| 55 | 91 | < 0.1% |
| 29 | 90 | < 0.1% |
| 35 | 84 | < 0.1% |
| 49 | 76 | < 0.1% |
| 39 | 74 | < 0.1% |
| 200 | 72 | < 0.1% |
| 61 | 71 | < 0.1% |
| 100 | 68 | < 0.1% |
| Other values (81774) | 319261 | |
| (Missing) | 15231 | 4.5% |
| Value | Count | Frequency (%) |
| 0 | 6494 | |
| 1 | 16 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 9 | < 0.1% |
| 4 | 6 | < 0.1% |
| 5 | 13 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 4070959 | 1 | |
| 3785590 | 1 | |
| 3729985 | 1 | |
| 3517847 | 1 | |
| 3257853 | 1 | |
| 2967597 | 1 | |
| 2589781 | 1 | |
| 2563785 | 1 | |
| 2188463 | 1 | |
| 1966112 | 1 |
SALDO_CASTIGO_DATACREDITO_1
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 72316 |
|---|---|
| Distinct (%) | 25.1% |
| Missing | 53215 |
| Missing (%) | 15.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23672.54 |
| Minimum | 0 |
|---|---|
| Maximum | 3803208 |
| Zeros | 1059 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 578 |
| Q1 | 2549 |
| median | 7669 |
| Q3 | 22463 |
| 95-th percentile | 101972.5 |
| Maximum | 3803208 |
| Range | 3803208 |
| Interquartile range (IQR) | 19914 |
Descriptive statistics
| Standard deviation | 52219.779 |
|---|---|
| Coefficient of variation (CV) | 2.2059221 |
| Kurtosis | 524.40045 |
| Mean | 23672.54 |
| Median Absolute Deviation (MAD) | 6249 |
| Skewness | 12.840182 |
| Sum | 6.8293148 × 109 |
| Variance | 2.7269053 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1059 | 0.3% |
| 100 | 119 | < 0.1% |
| 753 | 117 | < 0.1% |
| 700 | 102 | < 0.1% |
| 55 | 100 | < 0.1% |
| 600 | 94 | < 0.1% |
| 500 | 91 | < 0.1% |
| 1000 | 83 | < 0.1% |
| 800 | 78 | < 0.1% |
| 999 | 64 | < 0.1% |
| Other values (72306) | 286584 | |
| (Missing) | 53215 | 15.6% |
| Value | Count | Frequency (%) |
| 0 | 1059 | |
| 6 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 9 | 3 | < 0.1% |
| 10 | 6 | < 0.1% |
| 11 | 3 | < 0.1% |
| 12 | 6 | < 0.1% |
| 13 | 7 | < 0.1% |
| 14 | 7 | < 0.1% |
| 15 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 3803208 | 1 | |
| 3785590 | 1 | |
| 3705766 | 1 | |
| 3514514 | 1 | |
| 3257853 | 1 | |
| 2557043 | 1 | |
| 2479062 | 1 | |
| 2187470 | 1 | |
| 1966112 | 1 | |
| 1649723 | 1 |
BANCOS_CREDITOS_ACTIVOS_1
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3053 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5104369 |
| Minimum | 0 |
|---|---|
| Maximum | 29 |
| Zeros | 12318 |
| Zeros (%) | 3.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 29 |
| Range | 29 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.0711341 |
|---|---|
| Coefficient of variation (CV) | 0.58999324 |
| Kurtosis | 1.6471729 |
| Mean | 3.5104369 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.90174942 |
| Sum | 1188820 |
| Variance | 4.2895963 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) |
| 3 | 70526 | |
| 2 | 65720 | |
| 4 | 58205 | |
| 5 | 40194 | |
| 1 | 39003 | |
| 6 | 24601 | 7.2% |
| 7 | 13732 | 4.0% |
| 0 | 12318 | 3.6% |
| 8 | 7110 | 2.1% |
| 9 | 3684 | 1.1% |
| Other values (15) | 3560 | 1.0% |
| (Missing) | 3053 | 0.9% |
| Value | Count | Frequency (%) |
| 0 | 12318 | 3.6% |
| 1 | 39003 | |
| 2 | 65720 | |
| 3 | 70526 | |
| 4 | 58205 | |
| 5 | 40194 | |
| 6 | 24601 | 7.2% |
| 7 | 13732 | 4.0% |
| 8 | 7110 | 2.1% |
| 9 | 3684 | 1.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| 21 | 2 | < 0.1% |
| 20 | 4 | < 0.1% |
| 19 | 13 | < 0.1% |
| 18 | 11 | < 0.1% |
| 17 | 18 | < 0.1% |
| 16 | 17 | < 0.1% |
| 15 | 62 |
RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 109391 |
|---|---|
| Distinct (%) | 35.6% |
| Missing | 34599 |
| Missing (%) | 10.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.88424506 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 6720 |
| Zeros (%) | 2.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1509545 |
| Q1 | 0.95548086 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.044519136 |
Descriptive statistics
| Standard deviation | 0.25733447 |
|---|---|
| Coefficient of variation (CV) | 0.29102166 |
| Kurtosis | 4.4184658 |
| Mean | 0.88424506 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.3723225 |
| Sum | 271557.85 |
| Variance | 0.066221028 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 189433 | |
| 0 | 6720 | 2.0% |
| 0.5 | 12 | < 0.1% |
| 0.8571428571 | 9 | < 0.1% |
| 0.9090909091 | 8 | < 0.1% |
| 0.9615384615 | 8 | < 0.1% |
| 0.9230769231 | 7 | < 0.1% |
| 0.9375 | 7 | < 0.1% |
| 0.75 | 6 | < 0.1% |
| 0.8965517241 | 6 | < 0.1% |
| Other values (109381) | 110891 | |
| (Missing) | 34599 | 10.1% |
| Value | Count | Frequency (%) |
| 0 | 6720 | |
| 6.997243086 × 10-5 | 1 | < 0.1% |
| 0.0001500180022 | 1 | < 0.1% |
| 0.0001638538424 | 1 | < 0.1% |
| 0.0002108082637 | 1 | < 0.1% |
| 0.0002341621253 | 1 | < 0.1% |
| 0.0002486130941 | 1 | < 0.1% |
| 0.0002684464357 | 1 | < 0.1% |
| 0.0002887302797 | 1 | < 0.1% |
| 0.000295476523 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 189433 | |
| 0.9999986363 | 1 | < 0.1% |
| 0.9999984087 | 1 | < 0.1% |
| 0.99999743 | 1 | < 0.1% |
| 0.9999965015 | 1 | < 0.1% |
| 0.9999962353 | 1 | < 0.1% |
| 0.9999960386 | 1 | < 0.1% |
| 0.9999955013 | 1 | < 0.1% |
| 0.9999947652 | 1 | < 0.1% |
| 0.999994756 | 1 | < 0.1% |
Tipo_Cliente
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.5 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 341706 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 194993 | |
| 1 | 146713 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 194993 | |
| 1 | 146713 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 194993 | |
| 1 | 146713 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 341706 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 194993 | |
| 1 | 146713 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 341706 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 194993 | |
| 1 | 146713 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 341706 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 194993 | |
| 1 | 146713 |
Base
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.1 MiB |
| Aplicación | |
|---|---|
| Desarrollo |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3417060 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Desarrollo |
|---|---|
| 2nd row | Aplicación |
| 3rd row | Aplicación |
| 4th row | Aplicación |
| 5th row | Aplicación |
Common Values
| Value | Count | Frequency (%) |
| Aplicación | 194993 | |
| Desarrollo | 146713 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| aplicación | 194993 | |
| desarrollo | 146713 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 488419 | |
| i | 389986 | |
| c | 389986 | |
| a | 341706 | |
| r | 293426 | |
| o | 293426 | |
| A | 194993 | 5.7% |
| p | 194993 | 5.7% |
| ó | 194993 | 5.7% |
| n | 194993 | 5.7% |
| Other values (3) | 440139 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3075354 | |
| Uppercase Letter | 341706 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 488419 | |
| i | 389986 | |
| c | 389986 | |
| a | 341706 | |
| r | 293426 | |
| o | 293426 | |
| p | 194993 | 6.3% |
| ó | 194993 | 6.3% |
| n | 194993 | 6.3% |
| e | 146713 | 4.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 194993 | |
| D | 146713 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3417060 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 488419 | |
| i | 389986 | |
| c | 389986 | |
| a | 341706 | |
| r | 293426 | |
| o | 293426 | |
| A | 194993 | 5.7% |
| p | 194993 | 5.7% |
| ó | 194993 | 5.7% |
| n | 194993 | 5.7% |
| Other values (3) | 440139 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3222067 | |
| None | 194993 | 5.7% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 488419 | |
| i | 389986 | |
| c | 389986 | |
| a | 341706 | |
| r | 293426 | |
| o | 293426 | |
| A | 194993 | 6.1% |
| p | 194993 | 6.1% |
| n | 194993 | 6.1% |
| D | 146713 | 4.6% |
| Other values (2) | 293426 |
None
| Value | Count | Frequency (%) |
| ó | 194993 |
| BANCOS_CREDITOS_ACTIVOS | BANCOS_CREDITOS_ACTIVOS_1 | Base | CUOTAS_MERCADO_1 | Edad__c | Entidad_principal | Genero__c | Motivo_Renuencia_Cliente | Operado_Por__c | RANGO_EDAD | RANGO_EDAD_1 | RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO | RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 | SALDO_CASTIGO_DATACREDITO | SALDO_CASTIGO_DATACREDITO_1 | SALDO_TOTAL_DATACREDITO | SALDO_TOTAL_DATACREDITO_1 | Saldo_Capital_cliente | Saldo_Total_cliente | Tipo_Cliente | estado | localizado_historico | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BANCOS_CREDITOS_ACTIVOS | 1.000 | 0.548 | 0.009 | 0.300 | 0.088 | 0.161 | 0.018 | 0.016 | 0.070 | 0.036 | 0.027 | -0.368 | -0.247 | 0.227 | 0.210 | 0.370 | 0.292 | 0.103 | 0.031 | 0.009 | 0.014 | 0.031 |
| BANCOS_CREDITOS_ACTIVOS_1 | 0.548 | 1.000 | 0.029 | 0.464 | 0.098 | 0.091 | 0.022 | 0.040 | 0.058 | 0.038 | 0.051 | -0.300 | -0.296 | 0.301 | 0.305 | 0.409 | 0.458 | 0.153 | 0.135 | 0.029 | 0.040 | 0.094 |
| Base | 0.009 | 0.029 | 1.000 | -0.129 | -0.043 | 0.367 | 0.035 | 0.966 | 0.672 | 0.139 | 0.118 | -0.160 | -0.204 | -0.017 | -0.055 | 0.016 | -0.083 | 0.091 | -0.027 | 1.000 | 0.639 | 0.832 |
| CUOTAS_MERCADO_1 | 0.300 | 0.464 | -0.129 | 1.000 | 0.261 | 0.042 | 0.008 | 0.015 | 0.062 | 0.016 | 0.017 | -0.046 | 0.065 | 0.645 | 0.837 | 0.638 | 0.798 | 0.547 | 0.593 | 0.020 | 0.013 | 0.012 |
| Edad__c | 0.088 | 0.098 | -0.043 | 0.261 | 1.000 | 0.200 | 0.049 | 0.070 | 0.109 | 0.581 | 0.562 | -0.067 | -0.025 | 0.255 | 0.187 | 0.254 | 0.209 | 0.204 | 0.248 | 0.127 | 0.092 | 0.070 |
| Entidad_principal | 0.161 | 0.091 | 0.367 | 0.042 | 0.200 | 1.000 | 0.116 | 0.207 | 0.418 | 0.184 | 0.193 | -0.133 | -0.117 | -0.035 | 0.096 | 0.040 | 0.100 | -0.044 | -0.093 | 0.367 | 0.219 | 0.235 |
| Genero__c | 0.018 | 0.022 | 0.035 | 0.008 | 0.049 | 0.116 | 1.000 | 0.044 | 0.088 | 0.038 | 0.056 | 0.025 | 0.028 | 0.065 | 0.052 | 0.059 | 0.049 | 0.066 | 0.061 | 0.035 | 0.037 | 0.020 |
| Motivo_Renuencia_Cliente | 0.016 | 0.040 | 0.966 | 0.015 | 0.070 | 0.207 | 0.044 | 1.000 | 0.527 | 0.079 | 0.073 | 0.185 | 0.236 | 0.071 | 0.134 | 0.029 | 0.159 | -0.041 | 0.097 | 0.966 | 0.606 | 0.875 |
| Operado_Por__c | 0.070 | 0.058 | 0.672 | 0.062 | 0.109 | 0.418 | 0.088 | 0.527 | 1.000 | 0.121 | 0.128 | -0.063 | -0.044 | -0.047 | -0.103 | -0.039 | -0.085 | 0.047 | 0.012 | 0.672 | 0.583 | 0.494 |
| RANGO_EDAD | 0.036 | 0.038 | 0.139 | 0.016 | 0.581 | 0.184 | 0.038 | 0.079 | 0.121 | 1.000 | 0.703 | -0.035 | -0.005 | 0.271 | 0.243 | 0.263 | 0.259 | 0.209 | 0.270 | 0.139 | 0.095 | 0.081 |
| RANGO_EDAD_1 | 0.027 | 0.051 | 0.118 | 0.017 | 0.562 | 0.193 | 0.056 | 0.073 | 0.128 | 0.703 | 1.000 | -0.040 | 0.003 | 0.300 | 0.257 | 0.290 | 0.270 | 0.246 | 0.305 | 0.118 | 0.084 | 0.070 |
| RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO | -0.368 | -0.300 | -0.160 | -0.046 | -0.067 | -0.133 | 0.025 | 0.185 | -0.063 | -0.035 | -0.040 | 1.000 | 0.526 | 0.047 | -0.016 | -0.198 | -0.144 | -0.058 | 0.017 | 0.125 | 0.080 | 0.077 |
| RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 | -0.247 | -0.296 | -0.204 | 0.065 | -0.025 | -0.117 | 0.028 | 0.236 | -0.044 | -0.005 | 0.003 | 0.526 | 1.000 | 0.030 | 0.053 | -0.121 | -0.064 | -0.003 | 0.066 | 0.185 | 0.166 | 0.103 |
| SALDO_CASTIGO_DATACREDITO | 0.227 | 0.301 | -0.017 | 0.645 | 0.255 | -0.035 | 0.065 | 0.071 | -0.047 | 0.271 | 0.300 | 0.047 | 0.030 | 1.000 | 0.808 | 0.881 | 0.709 | 0.733 | 0.742 | 0.013 | 0.010 | 0.007 |
| SALDO_CASTIGO_DATACREDITO_1 | 0.210 | 0.305 | -0.055 | 0.837 | 0.187 | 0.096 | 0.052 | 0.134 | -0.103 | 0.243 | 0.257 | -0.016 | 0.053 | 0.808 | 1.000 | 0.771 | 0.915 | 0.698 | 0.725 | 0.015 | 0.011 | 0.012 |
| SALDO_TOTAL_DATACREDITO | 0.370 | 0.409 | 0.016 | 0.638 | 0.254 | 0.040 | 0.059 | 0.029 | -0.039 | 0.263 | 0.290 | -0.198 | -0.121 | 0.881 | 0.771 | 1.000 | 0.807 | 0.690 | 0.675 | 0.013 | 0.009 | 0.007 |
| SALDO_TOTAL_DATACREDITO_1 | 0.292 | 0.458 | -0.083 | 0.798 | 0.209 | 0.100 | 0.049 | 0.159 | -0.085 | 0.259 | 0.270 | -0.144 | -0.064 | 0.709 | 0.915 | 0.807 | 1.000 | 0.609 | 0.631 | 0.017 | 0.013 | 0.009 |
| Saldo_Capital_cliente | 0.103 | 0.153 | 0.091 | 0.547 | 0.204 | -0.044 | 0.066 | -0.041 | 0.047 | 0.209 | 0.246 | -0.058 | -0.003 | 0.733 | 0.698 | 0.690 | 0.609 | 1.000 | 0.939 | 0.013 | 0.019 | 0.003 |
| Saldo_Total_cliente | 0.031 | 0.135 | -0.027 | 0.593 | 0.248 | -0.093 | 0.061 | 0.097 | 0.012 | 0.270 | 0.305 | 0.017 | 0.066 | 0.742 | 0.725 | 0.675 | 0.631 | 0.939 | 1.000 | 0.010 | 0.010 | 0.006 |
| Tipo_Cliente | 0.009 | 0.029 | 1.000 | 0.020 | 0.127 | 0.367 | 0.035 | 0.966 | 0.672 | 0.139 | 0.118 | 0.125 | 0.185 | 0.013 | 0.015 | 0.013 | 0.017 | 0.013 | 0.010 | 1.000 | 0.639 | 0.832 |
| estado | 0.014 | 0.040 | 0.639 | 0.013 | 0.092 | 0.219 | 0.037 | 0.606 | 0.583 | 0.095 | 0.084 | 0.080 | 0.166 | 0.010 | 0.011 | 0.009 | 0.013 | 0.019 | 0.010 | 0.639 | 1.000 | 0.412 |
| localizado_historico | 0.031 | 0.094 | 0.832 | 0.012 | 0.070 | 0.235 | 0.020 | 0.875 | 0.494 | 0.081 | 0.070 | 0.077 | 0.103 | 0.007 | 0.012 | 0.007 | 0.009 | 0.003 | 0.006 | 0.832 | 0.412 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Contacto__c | Entidad_principal | Operado_Por__c | Saldo_Capital_cliente | Saldo_Total_cliente | Edad__c | Genero__c | Ciudad | estado | localizado_historico | Motivo_Renuencia_Cliente | RANGO_EDAD | FECHA_RECEPCION | PUNTAJE | INGRESOS_ESTIMADOS_DATACREDITO | SALDO_TOTAL_DATACREDITO | SALDO_CASTIGO_DATACREDITO | BANCOS_CREDITOS_ACTIVOS | RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO | RANGO_EDAD_1 | FECHA_RECEPCION_1 | PUNTAJE_1 | INGRESOS_ESTIMADOS_DATACREDITO_1 | CUOTAS_MERCADO_1 | SALDO_TOTAL_DATACREDITO_1 | SALDO_CASTIGO_DATACREDITO_1 | BANCOS_CREDITOS_ACTIVOS_1 | RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 | Tipo_Cliente | Base | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0036e000043bxo7AAA | BANCO DE BOGOTA4 | AYS_BB4 | 48736057 | 106341454 | 34.0 | M | SIN INFORMACION | POR_ACORDAR | LOCALIZADO | CLIENTE NO PERDIDO QUIEN NO ACEPTA POR DIVERSOS MOTIVOS | 29-35 | 2019-03-09 00:00:00 UTC | 389 - 869 | 1689-1754 | 95424.0 | 55851.0 | 2.0 | 0.585293 | 36-45 | 2022-03-07 00:00:00 UTC | 366 - 437 | 1521 - 1860 | 752.0 | 124652.0 | 98144.0 | 4.0 | 0.787344 | 1 | Desarrollo |
| 1 | 0035A00003XlKblQAF | GRUPO SOL | DIGITAL | 2698242 | 2738123 | 122.0 | M | SIN INFORMACION | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | Aplicación |
| 2 | 0036e000046v5rCAAQ | GRUPO SOL | DIGITAL | 206149 | 209196 | 41.0 | M | NaN | NaN | NaN | NaN | 36-45 | 2022-05-03 00:00:00 UTC | EXCLUSIONES | 1521 - 1860 | 94.0 | NaN | 1.0 | 1.000000 | 36-45 | 2022-05-03 00:00:00 UTC | EXCLUSIONES | 1521 - 1860 | 0.0 | 94.0 | NaN | 1.0 | 1.000000 | 0 | Aplicación |
| 3 | 0035A00003XihQkQAJ | GRUPO SOL | DIGITAL | 2701257 | 2741183 | 60.0 | M | SIN INFORMACION | NaN | NaN | NaN | 56-65 | 2019-03-21 00:00:00 UTC | 248 - 269 | 2426-2947 | 10797.0 | 1750.0 | 1.0 | 0.959896 | 56-65 | 2022-05-03 00:00:00 UTC | 222 - 293 | 3421 - 3860 | 8807.0 | 9977.0 | 723.0 | 4.0 | 0.935852 | 0 | Aplicación |
| 4 | 0035A00003XihVTQAZ | GRUPO SOL | DIGITAL | 2046427 | 2076674 | 73.0 | M | SIN INFORMACION | NaN | NaN | NaN | 66+ | 2019-03-21 00:00:00 UTC | 331 - 352 | 1755-1911 | 580.0 | 358.0 | 1.0 | 0.717241 | 66+ | 2022-05-03 00:00:00 UTC | 294 - 365 | 1521 - 1860 | 529.0 | 457.0 | 358.0 | 3.0 | 1.000000 | 0 | Aplicación |
| 5 | 0036e000046v5raAAA | GRUPO SOL | DIGITAL | 838503 | 850897 | 61.0 | M | NaN | NaN | NaN | NaN | 56-65 | 2019-03-21 00:00:00 UTC | 389 - 869 | 1324-1514 | 324.0 | 0.0 | 0.0 | 1.000000 | 56-65 | 2022-05-03 00:00:00 UTC | 726 - 797 | 1521 - 1860 | 0.0 | NaN | NaN | 0.0 | NaN | 0 | Aplicación |
| 6 | 0035A00003XlKatQAF | GRUPO SOL | DIGITAL | 628330 | 637617 | 122.0 | M | SIN INFORMACION | NaN | NaN | CLIENTE PERDIDO | 56-65 | 2022-05-03 00:00:00 UTC | EXCLUSIONES | 2221 - 2600 | 1430.0 | 1028.0 | 2.0 | 1.000000 | 56-65 | 2022-05-03 00:00:00 UTC | EXCLUSIONES | 2221 - 2600 | 1028.0 | 1430.0 | 1028.0 | 2.0 | 1.000000 | 0 | Aplicación |
| 7 | 0035A00003XihSVQAZ | GRUPO SOL | DIGITAL | 1669268 | 1693941 | 39.0 | M | SIN INFORMACION | NaN | NaN | NaN | 36-45 | 2019-03-21 00:00:00 UTC | 389 - 869 | 1324-1514 | 9697.0 | 0.0 | 0.0 | 0.000000 | 36-45 | 2022-05-03 00:00:00 UTC | EXCLUSIONES | 1201 - 1520 | 109.0 | 9648.0 | 9648.0 | 1.0 | 1.000000 | 0 | Aplicación |
| 8 | 0035A00003XihVBQAZ | GRUPO SOL | DIGITAL | 3363934 | 3413654 | 74.0 | M | SIN INFORMACION | NaN | NaN | NaN | 66+ | 2019-03-21 00:00:00 UTC | 150 - 239 | 2948-18548 | 59619.0 | 33087.0 | 3.0 | 1.000000 | 66+ | 2022-05-03 00:00:00 UTC | EXCLUSIONES | 1521 - 1860 | 0.0 | 543.0 | NaN | 1.0 | 1.000000 | 0 | Aplicación |
| 9 | 0035A00003XihV6QAJ | GRUPO SOL | DIGITAL | 987561 | 1002158 | 57.0 | M | SIN INFORMACION | NaN | NaN | NaN | 46-55 | 2019-03-21 00:00:00 UTC | EXCLUSIONES | 1912-2210 | 1450.0 | 1450.0 | 1.0 | 1.000000 | 46-55 | 2022-05-03 00:00:00 UTC | 222 - 293 | 3001 - 3420 | 560.0 | 585.0 | 161.0 | 3.0 | 0.317949 | 0 | Aplicación |
| Contacto__c | Entidad_principal | Operado_Por__c | Saldo_Capital_cliente | Saldo_Total_cliente | Edad__c | Genero__c | Ciudad | estado | localizado_historico | Motivo_Renuencia_Cliente | RANGO_EDAD | FECHA_RECEPCION | PUNTAJE | INGRESOS_ESTIMADOS_DATACREDITO | SALDO_TOTAL_DATACREDITO | SALDO_CASTIGO_DATACREDITO | BANCOS_CREDITOS_ACTIVOS | RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO | RANGO_EDAD_1 | FECHA_RECEPCION_1 | PUNTAJE_1 | INGRESOS_ESTIMADOS_DATACREDITO_1 | CUOTAS_MERCADO_1 | SALDO_TOTAL_DATACREDITO_1 | SALDO_CASTIGO_DATACREDITO_1 | BANCOS_CREDITOS_ACTIVOS_1 | RATIO_MORA_DEL_SALDO_TOTAL_REPORTADO_1 | Tipo_Cliente | Base | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 341697 | 0035A00003XiSJZQA3 | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 6701749 | 18212187 | 37.0 | M | CALI | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 29-35 | 2018-11-18 00:00:00 UTC | 150 | 1382798.34 | 50338.0 | 17738.0 | NaN | 0.998609 | 29-35 | 2022-03-07 00:00:00 UTC | 150 - 221 | 3421 - 3860 | 25179.0 | 52953.0 | 50655.0 | 8.0 | 1.000000 | 0 | Aplicación |
| 341698 | 0035A00003XiRbwQAF | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 7565490 | 18953217 | 64.0 | M | BOGOTA D.C. | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 56-65 | 2018-11-18 00:00:00 UTC | 246 | 2765596.68 | NaN | NaN | NaN | NaN | 56-65 | 2022-03-07 00:00:00 UTC | 222 - 293 | 3861 - 4320 | 20219.0 | 19951.0 | 19651.0 | 6.0 | 1.000000 | 0 | Aplicación |
| 341699 | 0035A00003XiRwjQAF | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 7216844 | 18666112 | 44.0 | F | NEIVA | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 36-45 | 2018-11-18 00:00:00 UTC | 1 | 1328111.4 | 14489.0 | 14489.0 | NaN | 1.000000 | 36-45 | 2022-03-07 00:00:00 UTC | 294 - 365 | 3421 - 3860 | 23864.0 | 23749.0 | 23311.0 | 7.0 | 0.991115 | 0 | Aplicación |
| 341700 | 0035A00003XiRnpQAF | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 8948803 | 33815255 | 44.0 | F | CALI | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 36-45 | 2018-11-18 00:00:00 UTC | 211 | 2187477.6 | 2682.0 | 2154.0 | NaN | 1.000000 | 46-55 | 2022-03-07 00:00:00 UTC | EXCLUSIONES | 3861 - 4320 | 32463.0 | 32632.0 | 32632.0 | 4.0 | 1.000000 | 0 | Aplicación |
| 341701 | 0035A00003XiRYTQA3 | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 4400249 | 11095602 | 64.0 | F | BARANOA | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 56-65 | 2018-11-18 00:00:00 UTC | 229 | 2945282.34 | NaN | NaN | NaN | NaN | 56-65 | 2022-03-07 00:00:00 UTC | 222 - 293 | 3421 - 3860 | 20832.0 | 21152.0 | 21152.0 | 7.0 | 1.000000 | 0 | Aplicación |
| 341702 | 0035A00003XiRcWQAV | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 10055794 | 23137452 | 64.0 | M | CALI | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 56-65 | 2018-11-18 00:00:00 UTC | 269 | 2351538.42 | NaN | NaN | NaN | NaN | 56-65 | 2022-03-07 00:00:00 UTC | 294 - 365 | 2601 - 3000 | 30985.0 | 28791.0 | 25080.0 | 4.0 | 1.000000 | 0 | Aplicación |
| 341703 | 0035A00003XiRRsQAN | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 7456832 | 29229171 | 64.0 | M | CALI | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 56-65 | 2018-11-18 00:00:00 UTC | 216 | 2296851.48 | 28115.0 | 17249.0 | NaN | 0.618104 | 66+ | 2022-03-07 00:00:00 UTC | 150 - 221 | 3001 - 3420 | 26963.0 | 49838.0 | 30356.0 | 8.0 | 0.616297 | 0 | Aplicación |
| 341704 | 0035A00003XiRsaQAF | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 9439405 | 21997584 | 64.0 | M | MANIZALES | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 56-65 | 2018-11-18 00:00:00 UTC | 150 | 4937449.44 | 64671.0 | 34227.0 | NaN | 0.542438 | 66+ | 2022-03-07 00:00:00 UTC | 150 - 221 | 3861 - 4320 | 33010.0 | 74661.0 | 40910.0 | 10.0 | 0.559368 | 0 | Aplicación |
| 341705 | 0035A00003XiS58QAF | BANCO DE BOGOTA3 | MANTENIMIENTO-ESP-QNT | 6054286 | 15617900 | 53.0 | M | CALI | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE SIN NINGUN CONTACTO HISTORICO | 46-55 | 2018-11-18 00:00:00 UTC | 194 | 3695274.66 | 24065.0 | 22839.0 | NaN | 0.965053 | 46-55 | 2022-03-07 00:00:00 UTC | 222 - 293 | 2221 - 2600 | 16025.0 | 17882.0 | 16025.0 | 5.0 | 0.908791 | 0 | Aplicación |
| 341706 | 0035A00003XiRl4QAF | GIROS Y FINANZAS | MANTENIMIENTO-ESP-QNT | 14989610 | 31047006 | 64.0 | M | CALI | POR_CONTACTAR | NO_LOCALIZADO | CLIENTE PERDIDO | 56-65 | 2018-11-18 00:00:00 UTC | 385 | 3109343.16 | NaN | NaN | NaN | NaN | 56-65 | 2022-03-07 00:00:00 UTC | 366 - 437 | 5821 - 6360 | 67085.0 | 45425.0 | 45356.0 | 4.0 | 0.998481 | 0 | Aplicación |